/*
 Navicat Premium Data Transfer

 Source Server         : chenlonghai
 Source Server Type    : MySQL
 Source Server Version : 50719
 Source Host           : localhost
 Source Database       : zlkg_db

 Target Server Type    : MySQL
 Target Server Version : 50719
 File Encoding         : utf-8

 Date: 08/02/2018 19:53:29 PM
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
--  Table structure for `Opinions`
-- ----------------------------
DROP TABLE IF EXISTS `Opinions`;
CREATE TABLE `Opinions` (
  `id` int(50) NOT NULL AUTO_INCREMENT,
  `tittle` varchar(100) NOT NULL COMMENT '标题',
  `content` text NOT NULL COMMENT '内容',
  `createTime` datetime DEFAULT NULL,
  `updateTime` datetime DEFAULT NULL,
  `imgUrl` text COMMENT '图片',
  `typeOne` varchar(5) DEFAULT NULL COMMENT '1 助力观点 2 助力资讯',
  `typeTwo` varchar(5) DEFAULT NULL COMMENT '1 新闻 2 活动 3 建设 4 评论 5 观点 6 文章',
  `linkUrl` text COMMENT '文章外链接',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `Opinions`
-- ----------------------------
BEGIN;
INSERT INTO `Opinions` VALUES ('5', '测试标题', '<p>你猜猜<img src=\"/image/20180802/1533206741843037342.jpg\" title=\"1533206741843037342.jpg\" alt=\"2018080121024312223.jpg\" width=\"208\" height=\"229\"/>这个美丽姑娘是谁</p>', '2018-08-02 18:46:30', '2018-08-02 18:46:30', '/images/opinion/2018080218452820180801212641timg.jpg', '2', '5', 'https://www.youku.com');
COMMIT;

-- ----------------------------
--  Table structure for `banner`
-- ----------------------------
DROP TABLE IF EXISTS `banner`;
CREATE TABLE `banner` (
  `id` int(50) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `imgUrl` text NOT NULL COMMENT '图片路径',
  `tittle` varchar(100) NOT NULL COMMENT '图片标题',
  `type` varchar(5) DEFAULT '' COMMENT '1 首页 2助力出品 3 助力文化 4 关于助力',
  `linkUrl` text COMMENT '外链接',
  `createTime` datetime DEFAULT NULL,
  `updateTime` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `banner`
-- ----------------------------
BEGIN;
INSERT INTO `banner` VALUES ('12', '/images/20180802174929banner1.jpg', '暂无', '1', 'https://mini.eastday.com/', '2018-08-02 17:49:32', '2018-08-02 17:51:33'), ('13', '/images/20180802175004banner2.jpg', '暂无', '2', 'https://mini.eastday.com', '2018-08-02 17:50:07', '2018-08-02 17:53:41'), ('14', '/images/20180802175021banner3.jpg', '暂无', '3', 'https://mini.eastday.com/', '2018-08-02 17:50:22', '2018-08-02 17:53:55'), ('15', '/images/2018080217503520180802170950zlkg_imgbook3.jpg', '暂无', '4', 'https://mini.eastday.com/', '2018-08-02 17:50:37', '2018-08-02 17:54:12');
COMMIT;

-- ----------------------------
--  Table structure for `cases`
-- ----------------------------
DROP TABLE IF EXISTS `cases`;
CREATE TABLE `cases` (
  `id` int(50) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `tittle` varchar(100) NOT NULL DEFAULT '' COMMENT '案例标题',
  `content` text NOT NULL COMMENT '案例内容',
  `imgUrl` text COMMENT '案例图片展示',
  `createTime` datetime DEFAULT NULL,
  `updateTime` datetime DEFAULT NULL,
  `linkUrl` text NOT NULL COMMENT '外链接',
  `type` varchar(50) NOT NULL DEFAULT '1' COMMENT '1 品牌营销与战略合作 2产品运营与平台托管 3影视制作与文化传播 4创意策划与活动运营 5品牌设计与产品开发 6 社区治理与服务提升',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `cases`
-- ----------------------------
BEGIN;
INSERT INTO `cases` VALUES ('8', '女孩生前告别会上怼亲友 真相令人心酸', '<p><span style=\"caret-color: rgb(51, 51, 51); color: rgb(51, 51, 51); font-family: 微软雅黑, &quot;Microsoft YaHei&quot;, arial, sans-serif; text-indent: 32px; text-size-adjust: auto; background-color: rgb(255, 255, 255);\">据台湾《联合报》近日报道，7月25日，高雄一男子余某在街上将路边摩托车篮子里的饮料罐顺走了，结果一口喝下后却倒地打滚，原来那瓶子里装的，其实是清洁工的除锈剂，最终余某送医后不治身亡。</span></p><p><span style=\"caret-color: rgb(51, 51, 51); color: rgb(51, 51, 51); font-family: 微软雅黑, &quot;Microsoft YaHei&quot;, arial, sans-serif; text-indent: 32px; text-size-adjust: auto; background-color: rgb(255, 255, 255);\"><img src=\"/image/20180802/1533203757842016416.jpg\" title=\"1533203757842016416.jpg\" alt=\"20180801212641timg.jpg\"/></span></p>', '/images/case/2018080217552820180731234812logo.png', '2018-08-02 17:56:08', '2018-08-02 17:56:08', 'https://www.baidu.com', '1'), ('9', '加拿大地铁上一非裔女性向亚裔女性大喊:滚回中国', '<p><span style=\"caret-color: rgb(51, 51, 51); color: rgb(51, 51, 51); font-family: 微软雅黑, &quot;Microsoft YaHei&quot;, arial, sans-serif; text-indent: 32px; text-size-adjust: auto; background-color: rgb(255, 255, 255);\">海外网8月2日电 加拿大多伦多地铁上日前发生一起冲突，一名非裔女子向周围乘客要烟抽，随后怀疑一名亚裔女子在拍照。该非裔女子立刻冲上前试图夺下亚裔女子的手机，并大喊“滚回中国”。多伦多警方正将此事件作为“抢劫案”进行调查。</span><img src=\"/image/20180802/1533203828470032863.jpg\" title=\"1533203828470032863.jpg\" alt=\"20180802170950zlkg_imgbook3.jpg\" width=\"618\" height=\"607\"/></p>', '/images/case/20180802175647banner2.jpg', '2018-08-02 17:57:23', '2018-08-02 17:57:23', 'https://www.baidu.com', '2');
COMMIT;

-- ----------------------------
--  Table structure for `contact`
-- ----------------------------
DROP TABLE IF EXISTS `contact`;
CREATE TABLE `contact` (
  `id` int(50) NOT NULL AUTO_INCREMENT COMMENT '联系我们表格',
  `userName` varchar(50) NOT NULL DEFAULT '' COMMENT '联系人',
  `userPhone` varchar(50) NOT NULL DEFAULT '' COMMENT '联系电话',
  `userDesc` varchar(200) NOT NULL DEFAULT '' COMMENT '项目描述',
  `createTime` datetime DEFAULT NULL,
  `updateTime` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `contact`
-- ----------------------------
BEGIN;
INSERT INTO `contact` VALUES ('1', '张三', '18500211300', '测试内容自己猜猜看', '2018-07-24 16:15:53', '2018-07-24 16:15:57'), ('2', '王五', '17801074377', '滑动滑动很多话滑动滑动好好读滑动滑动很多话滑动滑动很多话滑动滑动和卡卡卡卡卡', '2018-07-25 22:01:39', '2018-07-25 22:01:39');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
